-- --------------------------------------------------------

--
-- Table structure for table `ACheck`
--

CREATE TABLE `ACheck` (
  `CheckID` tinyint(4) NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `Password` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`CheckID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `ARss`
--

CREATE TABLE `ARss` (
  `RssID` float NOT NULL auto_increment,
  `Title` varchar(50) NOT NULL default '',
  `Url` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`RssID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `ASeo`
--

CREATE TABLE `ASeo` (
  `PageID` float NOT NULL auto_increment,
  `Page` varchar(100) NOT NULL default '',
  `Title` text NOT NULL,
  `Description` text NOT NULL,
  `Meta` text NOT NULL,
  PRIMARY KEY  (`PageID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `ASettings`
--

CREATE TABLE `ASettings` (
  `Id` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '',
  `EmailAddress` varchar(100) NOT NULL default '',
  `MConfirm` text NOT NULL,
  `MRequest` text NOT NULL,
  `MRequestok` text NOT NULL,
  `MPassword` text NOT NULL,
  `MInvite` text NOT NULL,
  `MMessage` text NOT NULL,
  `MBlog` text NOT NULL,
  `PhotoLimit` varchar(10) NOT NULL default '',
  `VoteTitle` varchar(100) NOT NULL default '',
  `VoteOption1` varchar(100) NOT NULL default '',
  `VoteOption2` varchar(100) NOT NULL default '',
  `VoteOption3` varchar(100) NOT NULL default '',
  `VoteOption4` varchar(100) NOT NULL default '',
  `Google_Api` text NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

INSERT INTO `ASettings` VALUES(1, '', '', '', '', '', '', '', '', '', '100', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `Blogs`
--

CREATE TABLE `Blogs` (
  `BlogID` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `Blog` text NOT NULL,
  `Title` varchar(100) NOT NULL default '',
  `Date` varchar(100) NOT NULL default '',
  `StartCode` tinyint(1) NOT NULL default '0',
  `FollowID` float NOT NULL default '0',
  PRIMARY KEY  (`BlogID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Comments`
--

CREATE TABLE `Comments` (
  `CommentId` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `PictureId` float NOT NULL default '0',
  `Blog` text NOT NULL,
  `Date` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`CommentId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Events`
--

CREATE TABLE `Events` (
  `EventID` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `Date` varchar(50) NOT NULL default '',
  `Type` varchar(10) NOT NULL default '',
  `TypeID` varchar(150) NOT NULL default '0',
  `DateID` date NOT NULL default '0000-00-00',
  `Timestamp` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`EventID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Friends`
--

CREATE TABLE `Friends` (
  `FriendID` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `FriendEmail` varchar(100) NOT NULL default '',
  `Active` tinyint(4) NOT NULL default '0',
  `Priority` tinyint(4) NOT NULL default '0',
  `NickNameA` varchar(20) NOT NULL default '',
  `NickNameB` varchar(20) NOT NULL default '',
  `FriendGroup` varchar(30) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`FriendID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `infoboard`
--

CREATE TABLE `infoboard` (
  `InfoID` float NOT NULL auto_increment,
  `Name` varchar(100) NOT NULL default '',
  `Information` text NOT NULL,
  `PictureInfo` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`InfoID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Location`
--

CREATE TABLE `Location` (
  `LocationID` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `Latitude` float NOT NULL default '0',
  `Longitude` float NOT NULL default '0',
  `Action` varchar(100) NOT NULL default '',
  `Time` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`LocationID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Message`
--

CREATE TABLE `Message` (
  `MessageId` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `MessageEmail` varchar(100) NOT NULL default '',
  `Message` text NOT NULL,
  `Date` varchar(100) NOT NULL default '',
  `ActiveA` tinyint(4) NOT NULL default '1',
  `ActiveB` tinyint(4) NOT NULL default '1',
  `ActiveC` tinyint(4) NOT NULL default '0',
  `Title` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`MessageId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Online`
--

CREATE TABLE `Online` (
  `OnlineID` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `Date` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`OnlineID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Persons`
--

CREATE TABLE `Persons` (
  `PersonID` float NOT NULL auto_increment,
  `FirstName` varchar(30) NOT NULL default '',
  `LastName` varchar(30) NOT NULL default '',
  `NickName` varchar(30) NOT NULL default '',
  `Education` varchar(15) NOT NULL default '',
  `EmailAddress` varchar(100) NOT NULL default '',
  `Password` varchar(100) NOT NULL default '',
  `PictureFile` varchar(100) NOT NULL default '',
  `City` varchar(30) NOT NULL default '',
  `Country` varchar(50) NOT NULL default '',
  `Active` tinyint(4) NOT NULL default '0',
  `Id` varchar(100) NOT NULL default '',
  `IP` varchar(50) NOT NULL default '0',
  `LogDate` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`PersonID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Pictures`
--

CREATE TABLE `Pictures` (
  `Number` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `PictureId` varchar(100) NOT NULL default '',
  `PictureoId` varchar(100) NOT NULL default '',
  `View` float NOT NULL default '0',
  `Ratetotal` float NOT NULL default '0',
  `Vote` float NOT NULL default '0',
  `Rating` float NOT NULL default '0',
  PRIMARY KEY  (`Number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Plan`
--

CREATE TABLE `Plan` (
  `PlanID` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `Plan` varchar(200) NOT NULL default '',
  `City` varchar(20) NOT NULL default '',
  `Visible` tinyint(1) NOT NULL default '0',
  `Date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`PlanID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Poll`
--

CREATE TABLE `Poll` (
  `PollID` float NOT NULL auto_increment,
  `A` tinyint(1) NOT NULL default '0',
  `B` tinyint(1) NOT NULL default '0',
  `C` tinyint(1) NOT NULL default '0',
  `D` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`PollID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `PollResults`
--

CREATE TABLE `PollResults` (
  `ID` float NOT NULL auto_increment,
  `Question` varchar(100) NOT NULL default '',
  `Answer1` varchar(100) NOT NULL default '',
  `Answer2` varchar(100) NOT NULL default '',
  `Answer3` varchar(100) NOT NULL default '',
  `Answer4` varchar(100) NOT NULL default '',
  `Result1` float NOT NULL default '0',
  `Result2` float NOT NULL default '0',
  `Result3` float NOT NULL default '0',
  `Result4` float NOT NULL default '0',
  `Date` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Rating`
--

CREATE TABLE `Rating` (
  `RatingID` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `PictureNo` float NOT NULL default '0',
  PRIMARY KEY  (`RatingID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Template`
--

CREATE TABLE `Template` (
  `TemplateID` int(11) NOT NULL default '0',
  `Body_Hex` varchar(20) NOT NULL default '',
  `Box_Hex` varchar(20) NOT NULL default '',
  `Div_Hex` varchar(20) NOT NULL default '',
  `Title_Hex` varchar(20) NOT NULL default '',
  `Menu_Hex` varchar(20) NOT NULL default '',
  `Menu_Slide_Hex` varchar(20) NOT NULL default '',
  `Menu_Slide_Hover_Hex` varchar(20) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Template`
--

INSERT INTO `Template` VALUES(0, '#ffffff', '#f0f0f0', '#b6dfff', '#6d9bf7', '#6d9bf7', '#f0f0f0', '#6d9bf7');

--

-- --------------------------------------------------------

--
-- Table structure for table `URss`
--

CREATE TABLE `URss` (
  `UserID` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `RssID` float NOT NULL default '0',
  `Active` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `USettings`
--

CREATE TABLE `USettings` (
  `SettingsID` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `Profile` tinyint(1) NOT NULL default '1',
  `Friends` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`SettingsID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `VideoRating`
--

CREATE TABLE `VideoRating` (
  `RatingID` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `VideoID` varchar(100) NOT NULL default '0',
  `Number` float NOT NULL default '0',
  PRIMARY KEY  (`RatingID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Videos`
--

CREATE TABLE `Videos` (
  `Number` float NOT NULL auto_increment,
  `EmailAddress` varchar(100) NOT NULL default '',
  `Title` varchar(100) NOT NULL default '',
  `Description` text NOT NULL,
  `Date` varchar(100) NOT NULL default '',
  `View` float NOT NULL default '0',
  `Ratetotal` float NOT NULL default '0',
  `Vote` float NOT NULL default '0',
  `Rating` float NOT NULL default '0',
  `Picture` varchar(100) NOT NULL default '',
  `VideoID` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`Number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--

-- --------------------------------------------------------

--
-- Table structure for table `Weather`
--

CREATE TABLE `Weather` (
  `WeatherID` float NOT NULL auto_increment,
  `City` varchar(50) NOT NULL default '',
  `Country` varchar(40) NOT NULL default '',
  `Code` tinyint(4) NOT NULL default '0',
  `Rss` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`WeatherID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `Weather`
--

INSERT INTO `Weather` VALUES(1, 'Aarau', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0001&u=c');
INSERT INTO `Weather` VALUES(2, 'Basel', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0004&u=c');
INSERT INTO `Weather` VALUES(3, 'Bellinzona', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0005&u=c');
INSERT INTO `Weather` VALUES(4, 'Bern', 'Switzerland', 1, 'http://weather.yahooapis.com/forecastrss?p=SZXX0006&u=c');
INSERT INTO `Weather` VALUES(5, 'Biel', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0007&u=c');
INSERT INTO `Weather` VALUES(6, 'Chur', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0038&u=c');
INSERT INTO `Weather` VALUES(7, 'Fribourg', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0012&u=c');
INSERT INTO `Weather` VALUES(8, 'Geneva', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0013&u=c');
INSERT INTO `Weather` VALUES(9, 'Gstaad', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0039&u=c');
INSERT INTO `Weather` VALUES(10, 'Interlaken', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0044&u=c');
INSERT INTO `Weather` VALUES(11, 'Lausanne', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0017&u=c');
INSERT INTO `Weather` VALUES(12, 'Locarno', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0019&u=c');
INSERT INTO `Weather` VALUES(13, 'Lugano', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0020&u=c');
INSERT INTO `Weather` VALUES(14, 'Luzern', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0021&u=c');
INSERT INTO `Weather` VALUES(15, 'Montreux', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0022&u=c');
INSERT INTO `Weather` VALUES(16, 'Neuchatel', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0023&u=c');
INSERT INTO `Weather` VALUES(17, 'Olten', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0024&u=c');
INSERT INTO `Weather` VALUES(18, 'Sion', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0035&u=c');
INSERT INTO `Weather` VALUES(19, 'Solothurn', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0027&u=c');
INSERT INTO `Weather` VALUES(20, 'St.Gallen', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0054&u=c');
INSERT INTO `Weather` VALUES(21, 'St.Moritz', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0041&u=c');
INSERT INTO `Weather` VALUES(22, 'Winterthur', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0030&u=c');
INSERT INTO `Weather` VALUES(23, 'Zug', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0032&u=c');
INSERT INTO `Weather` VALUES(24, 'Zurich', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0033&u=c');
INSERT INTO `Weather` VALUES(25, 'Delemont', 'Switzerland', 0, 'http://weather.yahooapis.com/forecastrss?p=SZXX0010&u=c');
INSERT INTO `Weather` VALUES(26, 'Adana', 'Turkey', 0, 'http://weather.yahooapis.com/forecastrss?p=TUXX0061&u=c');
INSERT INTO `Weather` VALUES(27, 'Ankara', 'Turkey', 1, 'http://weather.yahooapis.com/forecastrss?p=TUXX0002&u=c');
INSERT INTO `Weather` VALUES(28, 'Antalya', 'Turkey', 0, 'http://weather.yahooapis.com/forecastrss?p=TUXX0004&u=c');
INSERT INTO `Weather` VALUES(29, 'Bodrum', 'Turkey', 0, 'http://weather.yahooapis.com/forecastrss?p=TUXX0056&u=c');
INSERT INTO `Weather` VALUES(30, 'Bursa', 'Turkey', 0, 'http://weather.yahooapis.com/forecastrss?p=TUXX0039&u=c');
INSERT INTO `Weather` VALUES(31, 'Istanbul', 'Turkey', 0, 'http://weather.yahooapis.com/forecastrss?p=TUXX0014&u=c');
INSERT INTO `Weather` VALUES(32, 'Izmir', 'Turkey', 0, 'http://weather.yahooapis.com/forecastrss?p=TUXX0015&u=c');
INSERT INTO `Weather` VALUES(33, 'Trabzon', 'Turkey', 0, 'http://weather.yahooapis.com/forecastrss?p=TUXX0029&u=c');
INSERT INTO `Weather` VALUES(34, 'Kabul', 'Afghanistan', 1, 'http://weather.yahooapis.com/forecastrss?p=AFXX0003&u=c');
INSERT INTO `Weather` VALUES(35, 'Tirane', 'Albania', 1, 'http://weather.yahooapis.com/forecastrss?p=ALXX0002&u=c');
INSERT INTO `Weather` VALUES(36, 'Algiers', 'Algeria', 1, 'http://weather.yahooapis.com/forecastrss?p=AGXX0001&u=c');
INSERT INTO `Weather` VALUES(37, 'Pago Pago', 'AmericanSamoa', 1, 'http://weather.yahooapis.com/forecastrss?p=USAS0001&u=c');
INSERT INTO `Weather` VALUES(38, 'Andorra', 'Andorra', 1, 'http://weather.yahooapis.com/forecastrss?p=ANXX0001&u=c');
INSERT INTO `Weather` VALUES(39, 'Luanda', 'Angola', 1, 'http://weather.yahooapis.com/forecastrss?p=AOXX0008&u=c');
INSERT INTO `Weather` VALUES(40, 'Crocus Hill', 'Anguilla', 1, 'http://weather.yahooapis.com/forecastrss?p=AVXX0001&u=c');
INSERT INTO `Weather` VALUES(41, 'Codrington', 'Antigua&Barbuda', 1, 'http://weather.yahooapis.com/forecastrss?p=ACXX0001&u=c');
INSERT INTO `Weather` VALUES(42, 'Buenos Aires', 'Argentina', 1, 'http://weather.yahooapis.com/forecastrss?p=ARBA0009&u=c');
INSERT INTO `Weather` VALUES(43, 'Yerevan', 'Armenia', 1, 'http://weather.yahooapis.com/forecastrss?p=AMXX0003&u=c');
INSERT INTO `Weather` VALUES(44, 'Oranjestad', 'Aruba', 1, 'http://weather.yahooapis.com/forecastrss?p=AAXX0001&u=c');
INSERT INTO `Weather` VALUES(45, 'Sydney', 'Australia', 0, 'http://weather.yahooapis.com/forecastrss?p=ASXX0112&u=c');
INSERT INTO `Weather` VALUES(46, 'Melbourne', 'Australia', 0, 'http://weather.yahooapis.com/forecastrss?p=ASXX0075&u=c');
INSERT INTO `Weather` VALUES(47, 'Canberra', 'Australia', 1, 'http://weather.yahooapis.com/forecastrss?p=ASXX0023&u=c');
INSERT INTO `Weather` VALUES(48, 'Vienna', 'Austria', 1, 'http://weather.yahooapis.com/forecastrss?p=AUXX0025&u=c');
INSERT INTO `Weather` VALUES(49, 'Salzburg', 'Austria', 0, 'http://weather.yahooapis.com/forecastrss?p=AUXX0018&u=c');
INSERT INTO `Weather` VALUES(50, 'Baku', 'Azerbaijan', 1, 'http://weather.yahooapis.com/forecastrss?p=AJXX0001&u=c');
INSERT INTO `Weather` VALUES(51, 'Nassau', 'Bahamas', 1, 'http://weather.yahooapis.com/forecastrss?p=BFXX0005&u=c');
INSERT INTO `Weather` VALUES(52, 'Al Manama', 'Bahrain', 1, 'http://weather.yahooapis.com/forecastrss?p=BAXX0001&u=c');
INSERT INTO `Weather` VALUES(53, 'Dhaka', 'Bangladesh', 1, 'http://weather.yahooapis.com/forecastrss?p=BGXX0003&u=c');
INSERT INTO `Weather` VALUES(54, 'Bridgetown', 'Barbados', 1, 'http://weather.yahooapis.com/forecastrss?p=BBXX0001&u=c');
INSERT INTO `Weather` VALUES(55, 'Minsk', 'Belarus', 1, 'http://weather.yahooapis.com/forecastrss?p=BOXX0005&u=c');
INSERT INTO `Weather` VALUES(56, 'Brussels', 'Belgium', 1, 'http://weather.yahooapis.com/forecastrss?p=BEXX0005&u=c');
INSERT INTO `Weather` VALUES(57, 'Belmopan', 'Belize', 1, 'http://weather.yahooapis.com/forecastrss?p=BHXX0002&u=c');
INSERT INTO `Weather` VALUES(58, 'Porto-Novo', 'Benin', 1, 'http://weather.yahooapis.com/forecastrss?p=BNXX0002&u=c');
INSERT INTO `Weather` VALUES(59, 'Hamilton', 'Bermuda', 1, 'http://weather.yahooapis.com/forecastrss?p=BDXX0002&u=c');
INSERT INTO `Weather` VALUES(60, 'Thimphu', 'Bhutan', 1, 'http://weather.yahooapis.com/forecastrss?p=BTXX0002&u=c');
INSERT INTO `Weather` VALUES(61, 'Sucre', 'Bolivia', 1, 'http://weather.yahooapis.com/forecastrss?p=BLXX0013&u=c');
INSERT INTO `Weather` VALUES(62, 'Sarajevo', 'Bosnia&Herzegovina', 1, 'http://weather.yahooapis.com/forecastrss?p=BKXX0004&u=c');
INSERT INTO `Weather` VALUES(63, 'Brasilia', 'Brazil', 1, 'http://weather.yahooapis.com/forecastrss?p=BRXX0043&u=c');
INSERT INTO `Weather` VALUES(64, 'Kuala Belait', 'Brunei', 1, 'http://weather.yahooapis.com/forecastrss?p=BXXX0002&u=c');
INSERT INTO `Weather` VALUES(65, 'Sofia', 'Bulgaria', 1, 'http://weather.yahooapis.com/forecastrss?p=BUXX0005&u=c');
INSERT INTO `Weather` VALUES(66, 'Yaounde', 'Cameroon', 1, 'http://weather.yahooapis.com/forecastrss?p=CMXX0008&u=c');
INSERT INTO `Weather` VALUES(67, 'Toronto', 'Canada', 0, 'http://weather.yahooapis.com/forecastrss?p=CAXX0504&u=c');
INSERT INTO `Weather` VALUES(68, 'Ottowa', 'Canada', 1, 'http://weather.yahooapis.com/forecastrss?p=CAXX0343&u=c');
INSERT INTO `Weather` VALUES(69, 'Montreal', 'Canada', 0, 'http://weather.yahooapis.com/forecastrss?p=CAXX0301&u=c');
INSERT INTO `Weather` VALUES(70, 'Vancouver', 'Canada', 0, 'http://weather.yahooapis.com/forecastrss?p=CAXX0518&u=c');
INSERT INTO `Weather` VALUES(71, 'Santiago', 'Chile', 1, 'http://weather.yahooapis.com/forecastrss?p=CIXX0020&u=c');
INSERT INTO `Weather` VALUES(72, 'Beijing', 'China', 1, 'http://weather.yahooapis.com/forecastrss?p=CHXX0008&u=c');
INSERT INTO `Weather` VALUES(73, 'Bogota', 'Colombia', 1, 'http://weather.yahooapis.com/forecastrss?p=COXX0004&u=c');
INSERT INTO `Weather` VALUES(74, 'Kinshasa', 'Congo', 1, 'http://weather.yahooapis.com/forecastrss?p=CGXX0005&u=c');
INSERT INTO `Weather` VALUES(75, 'San Jose', 'Costa Rica', 1, 'http://weather.yahooapis.com/forecastrss?p=CSXX0009&u=c');
INSERT INTO `Weather` VALUES(76, 'Abidjan', 'IvoryCoast', 1, 'http://weather.yahooapis.com/forecastrss?p=IVXX0001&u=c');
INSERT INTO `Weather` VALUES(77, 'Zagreb', 'Croatia', 1, 'http://weather.yahooapis.com/forecastrss?p=HRXX0005&u=c');
INSERT INTO `Weather` VALUES(78, 'Havana', 'Cuba', 1, 'http://weather.yahooapis.com/forecastrss?p=CUXX0003&u=c');
INSERT INTO `Weather` VALUES(79, 'Nicosia', 'Cyprus', 1, 'http://weather.yahooapis.com/forecastrss?p=CYXX0005&u=c');
INSERT INTO `Weather` VALUES(80, 'Prague', 'CzechRepublic', 1, 'http://weather.yahooapis.com/forecastrss?p=EZXX0012&u=c');
INSERT INTO `Weather` VALUES(81, 'Copenhagen', 'Denmark', 1, 'http://weather.yahoo.com/Copenhagen-Denmark/DAXX0009/forecast.html?unit=c');
INSERT INTO `Weather` VALUES(82, 'Santo Domingo', 'Dominica', 1, 'http://weather.yahooapis.com/forecastrss?p=DRXX0009&u=c');
INSERT INTO `Weather` VALUES(83, 'Quito', 'Ecuador', 1, 'http://weather.yahooapis.com/forecastrss?p=ECXX0008&u=c');
INSERT INTO `Weather` VALUES(84, 'Cairo', 'Egypt', 1, 'http://weather.yahooapis.com/forecastrss?p=EGXX0004&u=c');
INSERT INTO `Weather` VALUES(85, 'San Salvador', 'ElSalvador', 1, 'http://weather.yahooapis.com/forecastrss?p=ESXX0001&u=c');
INSERT INTO `Weather` VALUES(86, 'Tallinn', 'Estonia', 1, 'http://weather.yahooapis.com/forecastrss?p=ENXX0004&u=c');
INSERT INTO `Weather` VALUES(87, 'Addis Ababa', 'Ethiopia', 1, 'http://weather.yahooapis.com/forecastrss?p=ETXX0001&u=c');
INSERT INTO `Weather` VALUES(88, 'Suva', 'Fiji', 1, 'http://weather.yahooapis.com/forecastrss?p=FJXX0009&u=c');
INSERT INTO `Weather` VALUES(89, 'Helsinki', 'Finland', 1, 'http://weather.yahooapis.com/forecastrss?p=FIXX0002&u=c');
INSERT INTO `Weather` VALUES(90, 'Paris', 'France', 1, 'http://weather.yahooapis.com/forecastrss?p=FRXX0076&u=c');
INSERT INTO `Weather` VALUES(91, 'Lyon', 'France', 0, 'http://weather.yahooapis.com/forecastrss?p=FRXX0055&u=c');
INSERT INTO `Weather` VALUES(92, 'Marseille', 'France', 0, 'http://weather.yahoo.com/Marseille-France/FRXX0059/forecast.html?unit=c');
INSERT INTO `Weather` VALUES(93, 'Bordeaux', 'France', 0, 'http://weather.yahooapis.com/forecastrss?p=FRXX0016&u=c');
INSERT INTO `Weather` VALUES(94, 'Tbilisi', 'Georgia', 1, 'http://weather.yahooapis.com/forecastrss?p=GGXX0004&u=c');
INSERT INTO `Weather` VALUES(95, 'Berlin', 'Germany', 1, 'http://weather.yahooapis.com/forecastrss?p=GMXX0007&u=c');
INSERT INTO `Weather` VALUES(96, 'Munchen', 'Germany', 0, 'http://weather.yahooapis.com/forecastrss?p=GMXX1002&u=c');
INSERT INTO `Weather` VALUES(97, 'Cologne', 'Germany', 0, 'http://weather.yahooapis.com/forecastrss?p=GMXX0018&u=c');
INSERT INTO `Weather` VALUES(98, 'Stuttgart', 'Germany', 0, 'http://weather.yahooapis.com/forecastrss?p=GMXX0128&u=c');
INSERT INTO `Weather` VALUES(99, 'Hannover', 'Germany', 0, 'http://weather.yahooapis.com/forecastrss?p=GMXX0051&u=c');
INSERT INTO `Weather` VALUES(100, 'Hamburg', 'Germany', 0, 'http://weather.yahooapis.com/forecastrss?p=GMXX0049&u=c');
INSERT INTO `Weather` VALUES(101, 'Duisburg', 'Germany', 0, 'http://weather.yahooapis.com/forecastrss?p=GMXX0027&u=c');
INSERT INTO `Weather` VALUES(102, 'Accra', 'Ghana', 1, 'http://weather.yahooapis.com/forecastrss?p=GHXX0001&u=c');
INSERT INTO `Weather` VALUES(103, 'Gibraltar', 'Gibraltar', 1, 'http://weather.yahooapis.com/forecastrss?p=GIXX0001&u=c');
INSERT INTO `Weather` VALUES(104, 'Athens', 'Greece', 1, 'http://weather.yahooapis.com/forecastrss?p=GRXX0004&u=c');
INSERT INTO `Weather` VALUES(105, 'Rhodes', 'Greece', 0, 'http://weather.yahooapis.com/forecastrss?p=GRXX0017&u=c');
INSERT INTO `Weather` VALUES(106, 'Larisa', 'Greece', 0, 'http://weather.yahooapis.com/forecastrss?p=GRXX0011&u=c');
INSERT INTO `Weather` VALUES(107, 'Godthab', 'Greenland', 1, 'http://weather.yahooapis.com/forecastrss?p=GLXX0003&u=c');
INSERT INTO `Weather` VALUES(108, 'Tegucigalpa', 'Honduras', 1, 'http://weather.yahooapis.com/forecastrss?p=HOXX0008&u=c');
INSERT INTO `Weather` VALUES(109, 'Hong Kong', 'HongKong', 1, 'http://weather.yahooapis.com/forecastrss?p=CHXX0049&u=c');
INSERT INTO `Weather` VALUES(110, 'Budapest', 'Hungary', 1, 'http://weather.yahooapis.com/forecastrss?p=HUXX0002&u=c');
INSERT INTO `Weather` VALUES(111, 'Reykjavik', 'Iceland', 1, 'http://weather.yahooapis.com/forecastrss?p=ICXX0002&u=c');
INSERT INTO `Weather` VALUES(112, 'New Delhi', 'India', 1, 'http://weather.yahooapis.com/forecastrss?p=INXX0096&u=c');
INSERT INTO `Weather` VALUES(113, 'Jakarta', 'Indonesia', 1, 'http://weather.yahooapis.com/forecastrss?p=IDXX0022&u=c');
INSERT INTO `Weather` VALUES(114, 'Tehran', 'Iran', 1, 'http://weather.yahooapis.com/forecastrss?p=IRXX0018&u=c');
INSERT INTO `Weather` VALUES(115, 'Baghdad', 'Iraq', 1, 'http://weather.yahooapis.com/forecastrss?p=IZXX0008&u=c');
INSERT INTO `Weather` VALUES(116, 'Dublin', 'Ireland', 1, 'http://weather.yahooapis.com/forecastrss?p=EIXX0014&u=c');
INSERT INTO `Weather` VALUES(117, 'Tel Aviv', 'Israel', 1, 'http://weather.yahooapis.com/forecastrss?p=ISXX0026&u=c');
INSERT INTO `Weather` VALUES(118, 'Rome', 'Italy', 1, 'http://weather.yahooapis.com/forecastrss?p=ITXX0067&u=c');
INSERT INTO `Weather` VALUES(119, 'Milano', 'Italy', 0, 'http://weather.yahooapis.com/forecastrss?p=ITXX0090&u=c');
INSERT INTO `Weather` VALUES(120, 'Turin', 'Italy', 0, 'http://weather.yahooapis.com/forecastrss?p=ITXX0081&u=c');
INSERT INTO `Weather` VALUES(121, 'Venice', 'Italy', 0, 'http://weather.yahooapis.com/forecastrss?p=ITXX0085&u=c');
INSERT INTO `Weather` VALUES(122, 'Kingston', 'Jamaica', 1, 'http://weather.yahooapis.com/forecastrss?p=JMXX0002&u=c');
INSERT INTO `Weather` VALUES(123, 'Tokyo', 'Japan', 1, 'http://weather.yahooapis.com/forecastrss?p=JAXX0085&u=c');
INSERT INTO `Weather` VALUES(124, 'Osaka', 'Japan', 0, 'http://weather.yahooapis.com/forecastrss?p=JAXX0071&u=c');
INSERT INTO `Weather` VALUES(125, 'Kobe', 'Japan', 0, 'http://weather.yahooapis.com/forecastrss?p=JAXX0040&u=c');
INSERT INTO `Weather` VALUES(126, 'Amman', 'Jordan', 1, 'http://weather.yahooapis.com/forecastrss?p=JOXX0002&u=c');
INSERT INTO `Weather` VALUES(127, 'Aqmola', 'Kazakhstan', 1, 'http://weather.yahooapis.com/forecastrss?p=KZXX0002&u=c');
INSERT INTO `Weather` VALUES(128, 'Nairobi', 'Kenya', 1, 'http://weather.yahooapis.com/forecastrss?p=KEXX0009&u=c');
INSERT INTO `Weather` VALUES(129, 'Kuwait City', 'Kuwait', 1, 'http://weather.yahooapis.com/forecastrss?p=KUXX0003&u=c');
INSERT INTO `Weather` VALUES(130, 'Bishkek', 'Kyrgyzstan', 1, 'http://weather.yahooapis.com/forecastrss?p=KGXX0001&u=c');
INSERT INTO `Weather` VALUES(131, 'Riga', 'Latvia', 1, 'http://weather.yahooapis.com/forecastrss?p=LGXX0004&u=c');
INSERT INTO `Weather` VALUES(132, 'Beirut', 'Lebanon', 1, 'http://weather.yahooapis.com/forecastrss?p=LEXX0003&u=c');
INSERT INTO `Weather` VALUES(133, 'Monrovia', 'Liberia', 1, 'http://weather.yahooapis.com/forecastrss?p=LIXX0002&u=c');
INSERT INTO `Weather` VALUES(134, 'Tripoli', 'Libya', 1, 'http://weather.yahooapis.com/forecastrss?p=LYXX0009&u=c');
INSERT INTO `Weather` VALUES(135, 'Vaduz', 'Liechtenstein', 1, 'http://weather.yahooapis.com/forecastrss?p=LSXX0002&u=c');
INSERT INTO `Weather` VALUES(136, 'Kaunas', 'Lithuania', 1, 'http://weather.yahooapis.com/forecastrss?p=LHXX0002&u=c');
INSERT INTO `Weather` VALUES(137, 'Luxembourg', 'Luxembourg', 1, 'http://weather.yahooapis.com/forecastrss?p=LUXX0003&u=c');
INSERT INTO `Weather` VALUES(138, 'Skopje', 'Macedonia', 1, 'http://weather.yahooapis.com/forecastrss?p=MKXX0001&u=c');
INSERT INTO `Weather` VALUES(139, 'Kuala Lumpur', 'Malaysia', 1, 'http://weather.yahooapis.com/forecastrss?p=MYXX0008&u=c');
INSERT INTO `Weather` VALUES(140, 'Valletta', 'Malta', 1, 'http://weather.yahooapis.com/forecastrss?p=MTXX0001&u=c');
INSERT INTO `Weather` VALUES(141, 'Mexico City', 'Mexico', 1, 'http://weather.yahooapis.com/forecastrss?p=MXDF0132&u=c');
INSERT INTO `Weather` VALUES(142, 'Kishinev', 'Moldova', 1, 'http://weather.yahooapis.com/forecastrss?p=MDXX0003&u=c');
INSERT INTO `Weather` VALUES(143, 'Monte Carlo', 'Monaco', 1, 'http://weather.yahooapis.com/forecastrss?p=MNXX0001&u=c');
INSERT INTO `Weather` VALUES(144, 'Casablanca', 'Morocco', 0, 'http://weather.yahooapis.com/forecastrss?p=MOXX0001&u=c');
INSERT INTO `Weather` VALUES(145, 'Rabat', 'Morocco', 1, 'http://weather.yahooapis.com/forecastrss?p=MOXX0007&u=c');
INSERT INTO `Weather` VALUES(146, 'Maputo', 'Mozambique', 1, 'http://weather.yahooapis.com/forecastrss?p=MZXX0003&u=c');
INSERT INTO `Weather` VALUES(147, 'Windhoek', 'Namibia', 1, 'http://weather.yahooapis.com/forecastrss?p=WAXX0004&u=c');
INSERT INTO `Weather` VALUES(148, 'Kathmandu', 'Nepal', 1, 'http://weather.yahooapis.com/forecastrss?p=NPXX0002&u=c');
INSERT INTO `Weather` VALUES(149, 'Amsterdam', 'Netherlands', 1, 'http://weather.yahooapis.com/forecastrss?p=NLXX0002&u=c');
INSERT INTO `Weather` VALUES(150, 'Rotterdam', 'Netherlands', 0, 'http://weather.yahooapis.com/forecastrss?p=NLXX0015&u=c');
INSERT INTO `Weather` VALUES(151, 'Twenthe', 'Netherlands', 0, 'http://weather.yahooapis.com/forecastrss?p=NLXX0023&u=c');
INSERT INTO `Weather` VALUES(152, 'Wellington', 'NewZealand', 1, 'http://weather.yahooapis.com/forecastrss?p=NZXX0049&u=c');
INSERT INTO `Weather` VALUES(153, 'Managua', 'Nicaragua', 1, 'http://weather.yahooapis.com/forecastrss?p=NZXX0049&u=c');
INSERT INTO `Weather` VALUES(154, 'Niamey', 'Niger', 1, 'http://weather.yahooapis.com/forecastrss?p=NGXX0003&u=c');
INSERT INTO `Weather` VALUES(155, 'Abuja', 'Nigeria', 1, 'http://weather.yahooapis.com/forecastrss?p=NGXX0003&u=c');
INSERT INTO `Weather` VALUES(156, 'Pyongyang', 'NorthKorea', 1, 'http://weather.yahooapis.com/forecastrss?p=KNXX0006&u=c');
INSERT INTO `Weather` VALUES(157, 'Oslo', 'Norway', 1, 'http://weather.yahooapis.com/forecastrss?p=NOXX0029&u=c');
INSERT INTO `Weather` VALUES(158, 'Muscat', 'Oman', 1, 'http://weather.yahooapis.com/forecastrss?p=MUXX0003&u=c');
INSERT INTO `Weather` VALUES(159, 'Islamabad', 'Pakistan', 1, 'http://weather.yahooapis.com/forecastrss?p=PKXX0006&u=c');
INSERT INTO `Weather` VALUES(160, 'Ramallah', 'Palestine', 1, 'http://weather.yahooapis.com/forecastrss?p=WEXX0005&u=c');
INSERT INTO `Weather` VALUES(161, 'Panama City', 'Panama', 1, 'http://weather.yahooapis.com/forecastrss?p=PMXX0004&u=c');
INSERT INTO `Weather` VALUES(162, 'Asuncion', 'Paraguay', 1, 'http://weather.yahooapis.com/forecastrss?p=PAXX0001&u=c');
INSERT INTO `Weather` VALUES(163, 'Lima', 'Peru', 1, 'http://weather.yahooapis.com/forecastrss?p=PEXX0011&u=c');
INSERT INTO `Weather` VALUES(164, 'Manila', 'Philippines', 1, 'http://weather.yahooapis.com/forecastrss?p=RPXX0017&u=c');
INSERT INTO `Weather` VALUES(165, 'Warsaw', 'Poland', 1, 'http://weather.yahooapis.com/forecastrss?p=PLXX0028&u=c');
INSERT INTO `Weather` VALUES(166, 'Lisbon', 'Portugal', 1, 'http://weather.yahooapis.com/forecastrss?p=POXX0016&u=c');
INSERT INTO `Weather` VALUES(167, 'Braga', 'Portugal', 0, 'http://weather.yahooapis.com/forecastrss?p=POXX0008&u=c');
INSERT INTO `Weather` VALUES(168, 'San Juan', 'PuertoRico', 1, 'http://weather.yahooapis.com/forecastrss?p=USPR0087&u=c');
INSERT INTO `Weather` VALUES(169, 'Doha', 'Qatar', 1, 'http://weather.yahooapis.com/forecastrss?p=QAXX0003&u=c');
INSERT INTO `Weather` VALUES(170, 'Bucharest', 'Romania', 1, 'http://weather.yahooapis.com/forecastrss?p=ROXX0003&u=c');
INSERT INTO `Weather` VALUES(171, 'Moscow', 'Russia', 1, 'http://weather.yahooapis.com/forecastrss?p=RSXX0063&u=c');
INSERT INTO `Weather` VALUES(172, 'Saint Petersburg', 'Russia', 0, 'http://weather.yahooapis.com/forecastrss?p=RSXX0091&u=c');
INSERT INTO `Weather` VALUES(173, 'San Marino', 'SanMarino', 1, 'http://weather.yahooapis.com/forecastrss?p=SMXX0001&u=c');
INSERT INTO `Weather` VALUES(174, 'Riyadh', 'SaudiArabia', 1, 'http://weather.yahooapis.com/forecastrss?p=SAXX0017&u=c');
INSERT INTO `Weather` VALUES(175, 'Belgrade', 'Serbia&Montenegro', 1, 'http://weather.yahooapis.com/forecastrss?p=YIXX0005&u=c');
INSERT INTO `Weather` VALUES(176, 'Dakar', 'Senegal', 1, 'http://weather.yahooapis.com/forecastrss?p=SGXX0001&u=c');
INSERT INTO `Weather` VALUES(177, 'Freetown', 'SierraLeone', 1, 'http://weather.yahooapis.com/forecastrss?p=SLXX0001&u=c');
INSERT INTO `Weather` VALUES(178, 'Singapore', 'Singapore', 1, 'http://weather.yahooapis.com/forecastrss?p=SNXX0006&u=c');
INSERT INTO `Weather` VALUES(179, 'Bratislava', 'Slovakia', 1, 'http://weather.yahooapis.com/forecastrss?p=LOXX0001&u=c');
INSERT INTO `Weather` VALUES(180, 'Ljubljana', 'Slovenia', 1, 'http://weather.yahooapis.com/forecastrss?p=SIXX0002&u=c');
INSERT INTO `Weather` VALUES(181, 'Cape Town', 'SouthAfrica', 1, 'http://weather.yahooapis.com/forecastrss?p=SFXX0010&u=c');
INSERT INTO `Weather` VALUES(182, 'Johannesburg', 'SouthAfrica', 0, 'http://weather.yahooapis.com/forecastrss?p=SFXX0023&u=c');
INSERT INTO `Weather` VALUES(183, 'Seoul', 'SouthKorea', 1, 'http://weather.yahooapis.com/forecastrss?p=KSXX0037&u=c');
INSERT INTO `Weather` VALUES(184, 'Madrid', 'Spain', 1, 'http://weather.yahooapis.com/forecastrss?p=SPXX0050&u=c');
INSERT INTO `Weather` VALUES(185, 'Barcelona', 'Spain', 0, 'http://weather.yahooapis.com/forecastrss?p=SPXX0015&u=c');
INSERT INTO `Weather` VALUES(186, 'Valencia', 'Spain', 0, 'http://weather.yahooapis.com/forecastrss?p=SPXX0082&u=c');
INSERT INTO `Weather` VALUES(187, 'Seville', 'Spain', 0, 'http://weather.yahooapis.com/forecastrss?p=SPXX0074&u=c');
INSERT INTO `Weather` VALUES(188, 'Sri Jayavardhanapura', 'SriLanka', 1, 'http://weather.yahooapis.com/forecastrss?p=CEXX0004&u=c');
INSERT INTO `Weather` VALUES(189, 'Stockholm', 'Sweden', 1, 'http://weather.yahooapis.com/forecastrss?p=SWXX0031&u=c');
INSERT INTO `Weather` VALUES(190, 'Helsingborg', 'Sweden', 0, 'http://weather.yahooapis.com/forecastrss?p=SWXX0010&u=c');
INSERT INTO `Weather` VALUES(191, 'Damascus', 'Syria', 1, 'http://weather.yahooapis.com/forecastrss?p=SYXX0004&u=c');
INSERT INTO `Weather` VALUES(192, 'Taipei', 'Taiwan', 1, 'http://weather.yahooapis.com/forecastrss?p=TWXX0021&u=c');
INSERT INTO `Weather` VALUES(193, 'Dushanbe', 'Tajikistan', 1, 'http://weather.yahooapis.com/forecastrss?p=TIXX0001&u=c');
INSERT INTO `Weather` VALUES(194, 'Bangkok', 'Thailand', 1, 'http://weather.yahooapis.com/forecastrss?p=THXX0002&u=c');
INSERT INTO `Weather` VALUES(195, 'Port Of Spain', 'Trinidad&Tobago', 1, 'http://weather.yahooapis.com/forecastrss?p=TDXX0002&u=c');
INSERT INTO `Weather` VALUES(196, 'Tunis', 'Tunisia', 1, 'http://weather.yahooapis.com/forecastrss?p=TSXX0010&u=c');
INSERT INTO `Weather` VALUES(197, 'Kampala', 'Uganda', 1, 'http://weather.yahooapis.com/forecastrss?p=UGXX0002&u=c');
INSERT INTO `Weather` VALUES(198, 'Kiev', 'Ukraine', 1, 'http://weather.yahooapis.com/forecastrss?p=UPXX0016&u=c');
INSERT INTO `Weather` VALUES(199, 'Abu Dhabi', 'UnitedArabEmirates', 1, 'http://weather.yahooapis.com/forecastrss?p=AEXX0001&u=c');
INSERT INTO `Weather` VALUES(200, 'London', 'UnitedKingdom', 1, 'http://weather.yahooapis.com/forecastrss?p=UKXX0085&u=c');
INSERT INTO `Weather` VALUES(201, 'Birmingham', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0018&u=c');
INSERT INTO `Weather` VALUES(202, 'Glasgow', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0061&u=c');
INSERT INTO `Weather` VALUES(203, 'Liverpool', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0083&u=c');
INSERT INTO `Weather` VALUES(204, 'Leeds', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0078&u=c');
INSERT INTO `Weather` VALUES(205, 'Sheffield', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0133&u=c');
INSERT INTO `Weather` VALUES(206, 'Edinburgh', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0052&u=c');
INSERT INTO `Weather` VALUES(207, 'Bristol', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0025&u=c');
INSERT INTO `Weather` VALUES(208, 'Manchester', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0092&u=c');
INSERT INTO `Weather` VALUES(209, 'Leicester', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0079&u=c');
INSERT INTO `Weather` VALUES(210, 'Coventry', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0038&u=c');
INSERT INTO `Weather` VALUES(211, 'Kingston Upon Hull', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0075&u=c');
INSERT INTO `Weather` VALUES(212, 'Bradford', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0023&u=c');
INSERT INTO `Weather` VALUES(213, 'Cardiff', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0030&u=c');
INSERT INTO `Weather` VALUES(214, 'Belfast', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0015&u=c');
INSERT INTO `Weather` VALUES(215, 'Stoke On Trent', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0142&u=c');
INSERT INTO `Weather` VALUES(216, 'Wolverhampton', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0159&u=c');
INSERT INTO `Weather` VALUES(217, 'Nottingham', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0104&u=c');
INSERT INTO `Weather` VALUES(218, 'Plymouth', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0112&u=c');
INSERT INTO `Weather` VALUES(219, 'Southampton', 'UnitedKingdom', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0138&u=c');
INSERT INTO `Weather` VALUES(220, 'Alabama', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USAL0375&u=c');
INSERT INTO `Weather` VALUES(221, 'Alaska', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USAK0116&u=c');
INSERT INTO `Weather` VALUES(222, 'Arizona', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USAZ0166&u=c');
INSERT INTO `Weather` VALUES(223, 'Arkansas', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USAR0336&u=c');
INSERT INTO `Weather` VALUES(224, 'California', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USCA0967&u=c');
INSERT INTO `Weather` VALUES(225, 'Colorado', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USCO0105&u=c');
INSERT INTO `Weather` VALUES(226, 'Connecticut', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USCT0094&u=c');
INSERT INTO `Weather` VALUES(227, 'Delaware', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USDE0012&u=c');
INSERT INTO `Weather` VALUES(228, 'Florida', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USFL0479&u=c');
INSERT INTO `Weather` VALUES(229, 'Georgia', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USGA0028&u=c');
INSERT INTO `Weather` VALUES(230, 'Hawaii', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USHI0026&u=c');
INSERT INTO `Weather` VALUES(231, 'Idaho', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USID0025&u=c');
INSERT INTO `Weather` VALUES(232, 'Illinois', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USIL1114&u=c');
INSERT INTO `Weather` VALUES(233, 'Indiana', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USIN0305&u=c');
INSERT INTO `Weather` VALUES(234, 'Iowa', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USIA0231&u=c');
INSERT INTO `Weather` VALUES(235, 'Kansas', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USKS0571&u=c');
INSERT INTO `Weather` VALUES(236, 'Kentucky', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USKY0919&u=c');
INSERT INTO `Weather` VALUES(237, 'Louisiana', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USLA0033&u=c');
INSERT INTO `Weather` VALUES(238, 'Maine', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USME0013&u=c');
INSERT INTO `Weather` VALUES(239, 'Maryland', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USMD0010&u=c');
INSERT INTO `Weather` VALUES(240, 'Massachusetts', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USMA0046&u=c');
INSERT INTO `Weather` VALUES(241, 'Michigan', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USMI0477&u=c');
INSERT INTO `Weather` VALUES(242, 'Minnesota', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USMN0664&u=c');
INSERT INTO `Weather` VALUES(243, 'Mississippi', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USMS0175&u=c');
INSERT INTO `Weather` VALUES(244, 'Missouri', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USMO0453&u=c');
INSERT INTO `Weather` VALUES(245, 'Montana', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USMT0163&u=c');
INSERT INTO `Weather` VALUES(246, 'Nebraska', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USNE0283&u=c');
INSERT INTO `Weather` VALUES(247, 'Nevada', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USNV0014&u=c');
INSERT INTO `Weather` VALUES(248, 'New Hampshire', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USNH0045&u=c');
INSERT INTO `Weather` VALUES(249, 'New Jersey', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USNJ0524&u=c');
INSERT INTO `Weather` VALUES(250, 'New Mexico', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USNM0292&u=c');
INSERT INTO `Weather` VALUES(251, 'New York', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USNY0011&u=c');
INSERT INTO `Weather` VALUES(252, 'North Carolina', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USNC0558&u=c');
INSERT INTO `Weather` VALUES(253, 'North Dakota', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USND0037&u=c');
INSERT INTO `Weather` VALUES(254, 'Ohio', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USOH0212&u=c');
INSERT INTO `Weather` VALUES(255, 'Oklahoma', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USOK0400&u=c');
INSERT INTO `Weather` VALUES(256, 'Oregon', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USOR0304&u=c');
INSERT INTO `Weather` VALUES(257, 'Pennsylvania', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USPA0679&u=c');
INSERT INTO `Weather` VALUES(258, 'Rhode Island', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USRI0050&u=c');
INSERT INTO `Weather` VALUES(259, 'South Carolina', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USSC0065&u=c');
INSERT INTO `Weather` VALUES(260, 'South Dakota', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USSD0269&u=c');
INSERT INTO `Weather` VALUES(261, 'Tennessee', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USTN0357&u=c');
INSERT INTO `Weather` VALUES(262, 'Texas', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USTX0057&u=c');
INSERT INTO `Weather` VALUES(263, 'Utah', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USUT0225&u=c');
INSERT INTO `Weather` VALUES(264, 'Vermont', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USVT0147&u=c');
INSERT INTO `Weather` VALUES(265, 'Virginia', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USVA0652&u=c');
INSERT INTO `Weather` VALUES(266, 'Washington', 'UnitedStates', 1, 'http://weather.yahooapis.com/forecastrss?p=USWA0318&u=c');
INSERT INTO `Weather` VALUES(267, 'West Virginia', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USWV0138&u=c');
INSERT INTO `Weather` VALUES(268, 'Wisconsin', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USWI0411&u=c');
INSERT INTO `Weather` VALUES(269, 'Wyoming', 'UnitedStates', 0, 'http://weather.yahooapis.com/forecastrss?p=USWY0032&u=c');
INSERT INTO `Weather` VALUES(270, 'Montevideo', 'Uruguay', 1, 'http://weather.yahooapis.com/forecastrss?p=UYXX0006&u=c');
INSERT INTO `Weather` VALUES(271, 'Tashkent', 'Uzbekistan', 1, 'http://weather.yahooapis.com/forecastrss?p=UZXX0004&u=c');
INSERT INTO `Weather` VALUES(272, 'Caracas', 'Venezuela', 1, 'http://weather.yahooapis.com/forecastrss?p=VEXX0008&u=c');
INSERT INTO `Weather` VALUES(273, 'Hanoi', 'Vietnam', 1, 'http://weather.yahooapis.com/forecastrss?p=VMXX0006&u=c');
INSERT INTO `Weather` VALUES(274, 'Sanaa', 'Yemen', 1, 'http://weather.yahooapis.com/forecastrss?p=YMXX0005&u=c');
INSERT INTO `Weather` VALUES(275, 'Lusaka', 'Zambia', 1, 'http://weather.yahooapis.com/forecastrss?p=ZAXX0004&u=c');
INSERT INTO `Weather` VALUES(276, 'Harare', 'Zimbabwe', 1, 'http://weather.yahooapis.com/forecastrss?p=ZIXX0004&u=c');
INSERT INTO `Weather` VALUES(277, 'Glasgow', 'Scotland', 0, 'http://weather.yahooapis.com/forecastrss?p=UKXX0061&u=c');
INSERT INTO `Weather` VALUES(278, 'Edinburgh', 'Scotland', 1, 'http://weather.yahooapis.com/forecastrss?p=UKXX0052&u=c');
INSERT INTO `Weather` VALUES(279, 'Cardiff', 'Wales', 1, 'http://weather.yahooapis.com/forecastrss?p=UKXX0030&u=c');
INSERT INTO `Weather` VALUES(280, 'Ouagadougou', 'BurkinaFaso', 1, 'http://weather.yahooapis.com/forecastrss?p=UVXX0001&u=c');
INSERT INTO `Weather` VALUES(281, 'Bujumbura', 'Burundi', 1, 'http://weather.yahooapis.com/forecastrss?p=BYXX0001&u=c');
INSERT INTO `Weather` VALUES(282, 'Antananarivo', 'Madagascar', 1, 'http://weather.yahooapis.com/forecastrss?p=MAXX0002&u=c');
INSERT INTO `Weather` VALUES(283, 'Kigali', 'Rwanda', 1, 'http://weather.yahooapis.com/forecastrss?p=RWXX0001&u=c');
INSERT INTO `Weather` VALUES(284, 'Seychelles', 'Seychelles', 1, 'http://weather.yahooapis.com/forecastrss?p=SEXX0001&u=c');
INSERT INTO `Weather` VALUES(285, 'Mbabane', 'Swaziland', 1, 'http://weather.yahooapis.com/forecastrss?p=WZXX0001&u=c');
INSERT INTO `Weather` VALUES(286, 'Lome', 'Togo', 1, 'http://weather.yahooapis.com/forecastrss?p=TOXX0001&u=c');
INSERT INTO `Weather` VALUES(287, 'Nouakchott', 'Mauritania', 1, 'http://weather.yahooapis.com/forecastrss?p=MRXX0004&u=c');
INSERT INTO `Weather` VALUES(288, 'Dodoma', 'Tanzania', 1, 'http://weather.yahooapis.com/forecastrss?p=TZXX0002&u=c');
INSERT INTO `Weather` VALUES(289, 'Bamako', 'Mali', 1, 'http://weather.yahooapis.com/forecastrss?p=MLXX0001&u=c');
INSERT INTO `Weather` VALUES(290, 'Bangui', 'CentralAfricanRepublic', 1, 'http://weather.yahooapis.com/forecastrss?p=CTXX0001&u=c');
INSERT INTO `Weather` VALUES(291, 'Ulan Bator', 'Mongolia', 1, 'http://weather.yahooapis.com/forecastrss?p=MGXX0003&u=c');
INSERT INTO `Weather` VALUES(292, 'Male', 'Maldives', 1, 'http://weather.yahooapis.com/forecastrss?p=MVXX0001&u=c');
INSERT INTO `Weather` VALUES(293, 'Vientiane', 'Laos', 1, 'http://weather.yahooapis.com/forecastrss?p=LAXX0001&u=c');
